'use strict';

module.exports = {
  async up(queryInterface, Sequelize) {
    const { INTEGER, DATE, STRING } = Sequelize;
    await queryInterface.createTable('projects', {
      id: { type: INTEGER, primaryKey: true, autoIncrement: true },
      project_name: STRING(255),
      project_address: STRING(255),
      project_users: STRING(512),
      deadline: DATE,
      logo_url: STRING(255),
      put_on_record: STRING(255),
      proxy_string: STRING(255),
      pro_env: STRING(512),
      dev_env: STRING(512),
      test_env: STRING(512),
      output_path: STRING(255),
      created_at: DATE,
      updated_at: DATE,
    });
  },

  async down(queryInterface) {
    await queryInterface.dropTable('projects');
  },
};
